UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1bL++sWjW7Xf2REuK50kwHavE4L71r/ZpqmP6i7qhjs='
WHERE
key_id = '7a46c1d154692e148a4ed6001eef73cfe213fc9da610bdd65cb7011e2d446474'
AND (
token = '1bL++sWjW7Xf2REuK50kwHavE4L71r/ZpqmP6i7qhjs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)