UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BSI5giIC+CDC/IgYGqWBvuxH+sCecOc0lakvSqRi5mU='
WHERE
key_id = 'e0db1881d0b5e22de42a2d9789b7e14cb51b7065b0c4ffc59b7ffcb982edb087'
AND (
token = 'BSI5giIC+CDC/IgYGqWBvuxH+sCecOc0lakvSqRi5mU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)