UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kKLP0IKYAhyS+ExrB7yILPCMg0/NNwKhJszySt/JtzM='
WHERE
key_id = 'ada94793e9951fb189effff5bc475e0e660654389540c28eb3e447126b6a644c'
AND (
token = 'kKLP0IKYAhyS+ExrB7yILPCMg0/NNwKhJszySt/JtzM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)