UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1rym0hRHARAnQGmZ8eQbqMCaZWJtEya+5kvbRibnYiM='
WHERE
key_id = 'c9b567f6b3394e6e0c11a6ffef4ff66ddf46ace5e5bd326495aab6d227f2b406'
AND (
token = '1rym0hRHARAnQGmZ8eQbqMCaZWJtEya+5kvbRibnYiM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)