UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CnFp6QpHOtbsCoIRN8gSngws45u/QsF00L5Ar7zD3+4='
WHERE
key_id = 'f3b69a9f3e4940bfbe4f3a9cce950bc943dca0e02161a1badf903972058a5757'
AND (
token = 'CnFp6QpHOtbsCoIRN8gSngws45u/QsF00L5Ar7zD3+4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)