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