UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cYuZiem+ziZa0g2dD5lcm2pcOI3yFGB12383snWiado='
WHERE
key_id = 'd9606718ec5d031f1789efa98b3eb68aec2e6a0353430e6c4e43e4c67be9cfa1'
AND (
token = 'cYuZiem+ziZa0g2dD5lcm2pcOI3yFGB12383snWiado='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)