UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5s7LgZuGfAbyjq4Fw384dhpbOE6N+WAUyT5hg5U25GA='
WHERE
key_id = '4c1e2e072ec1bbd2743e7a98a44ac204e173e2eebb917f04b7bdde1fecb06a42'
AND (
token = '5s7LgZuGfAbyjq4Fw384dhpbOE6N+WAUyT5hg5U25GA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)