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