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