UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6LX5dL6GehX3qkR/wTYmKR+UkJUvDd7UFJKi/kZNCrM='
WHERE
key_id = 'b2d68fbd0841bc805ca95b8cf528761ada734e562566f753946115fce84a40b0'
AND (
token = '6LX5dL6GehX3qkR/wTYmKR+UkJUvDd7UFJKi/kZNCrM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)