UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UvTIRg8lvFXAhDPCkq3/gCuJVvDrOdq7wuMYig3WXMo='
WHERE
key_id = 'a8a8aa48dc09046b2a3d8ec4040a6dbe501adba0efe2d99e494d4bac2bb3ee89'
AND (
token = 'UvTIRg8lvFXAhDPCkq3/gCuJVvDrOdq7wuMYig3WXMo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)