UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HiVv7g2Y1LpBpUif7JVPKW2iu09RgRT4SI4/ubpridU='
WHERE
key_id = '3defc1a9f89a7242d9e5fb65bd63ac2b85340ac054e1f5d5ac12e42c649743a2'
AND (
token = 'HiVv7g2Y1LpBpUif7JVPKW2iu09RgRT4SI4/ubpridU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)