UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v27QV7Qi15hp91vDpfIeDNvJGuWFphm5Grpb2AGEh6Y='
WHERE
key_id = 'd51a42fe9ffc787290c71c7600236c100f0ba2bbf7ea6f00e2827fb70b2906ae'
AND (
token = 'v27QV7Qi15hp91vDpfIeDNvJGuWFphm5Grpb2AGEh6Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)