UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/ZPiVrGcaECQZbHZKaBDZcZR0PVMv1yB650yg7vI5bQ='
WHERE
key_id = '5dd31a826a6bcb3843867e7aa7a2be23d90415dc0ffe41eb76efda7c122e37cb'
AND (
token = '/ZPiVrGcaECQZbHZKaBDZcZR0PVMv1yB650yg7vI5bQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)