UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0qn6Sk2OdefE+trS4awPUyGw807qIjSpG5JWjBRPAB4='
WHERE
key_id = 'f7499bd0e65e1a357a440fc28b321604576a666ddc6dd30649cf666654580116'
AND (
token = '0qn6Sk2OdefE+trS4awPUyGw807qIjSpG5JWjBRPAB4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)