UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jqy4B37BsymVnRfohgH5D5Vh1jP4znhfzuW6pkw3B3U='
WHERE
key_id = 'e87bd34d18a38b735504564888382705ab60c258929efcf21a9ef56cbffdeb27'
AND (
token = 'jqy4B37BsymVnRfohgH5D5Vh1jP4znhfzuW6pkw3B3U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)