UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zgAVnOXxBFSfanitjOkelG2vjSNWOnlqayCYjgcONu0='
WHERE
key_id = '1a4d803edf84070e36d6d6cfe9c51c63a2cbca41d25cdfc77034a2f45ebcf962'
AND (
token = 'zgAVnOXxBFSfanitjOkelG2vjSNWOnlqayCYjgcONu0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)