UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KRv9L2PTW7CKkJFZW+V4phdDDYrzFY+dlxySwN22LRo='
WHERE
key_id = '5a9ef543c90715913588649d7a80f9ed039705e26612599d7e06ac1af1b39ef2'
AND (
token = 'KRv9L2PTW7CKkJFZW+V4phdDDYrzFY+dlxySwN22LRo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)