UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p7Z8+EyFHLcCrNeA0ybJalN3gJBpouJ9AnmwU+aS91k='
WHERE
key_id = '0bd67e133f7a4ee1f6878595d279928e1718824d03c3d471b0639063213332a6'
AND (
token = 'p7Z8+EyFHLcCrNeA0ybJalN3gJBpouJ9AnmwU+aS91k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)