UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8YqsjLISFIQKthvIS0pB4Zh76fsPULTLb2FP8K7c3rM='
WHERE
key_id = 'ba2878a314104d2a13f5264f714c267a52292cd5fd9ece5da4753a6940ed58ec'
AND (
token = '8YqsjLISFIQKthvIS0pB4Zh76fsPULTLb2FP8K7c3rM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)