UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XZL9kBLpLkumF4felJiN1I37X/RYmzJ/ZFBwLg3qfI4='
WHERE
key_id = 'a1a0fc56e51afbf278b6b3b7eae01472def6e5eaf88af9222739734caeb7336c'
AND (
token = 'XZL9kBLpLkumF4felJiN1I37X/RYmzJ/ZFBwLg3qfI4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)