UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/TZElG/KbZwv1xRf2VDLFHAlhKahWn35caAbTQ1CIlg='
WHERE
key_id = 'ef24aa5b86b71421259c3c87c13c1d9d8e236d1afc1cd380386c2d9192ee0819'
AND (
token = '/TZElG/KbZwv1xRf2VDLFHAlhKahWn35caAbTQ1CIlg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)