UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bo8LagVMm71OUdACkPSF1yujHO1cWimnTUZfgAAkJZs='
WHERE
key_id = '42a9ae0317c23bf8568c7a2c4985fb1bb5f2421fb75f4becf45d0a4a655fc6ae'
AND (
token = 'bo8LagVMm71OUdACkPSF1yujHO1cWimnTUZfgAAkJZs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)