UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JSdekdch1XOxjnuAqarA0AZ3bH05imLj8v+TvWv+MN0='
WHERE
key_id = 'ec00ec30f0e6d08e13cb6cf6298313118ee7e77718fe6fdced01c4f11ef5462f'
AND (
token = 'JSdekdch1XOxjnuAqarA0AZ3bH05imLj8v+TvWv+MN0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)