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