UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XZj2Izwq6qA2RvCh7JlCQdPi2lRp+CiHiYjkB+JkGn0='
WHERE
key_id = '4b7c32e7344013380a20acd02f1c37d4893d58df54c8da8fdd98eabb944d51b3'
AND (
token = 'XZj2Izwq6qA2RvCh7JlCQdPi2lRp+CiHiYjkB+JkGn0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)