UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q4gS7UZyoc8Ru5uWGFvaDfDRmk30d1PQSqGF640Zvik='
WHERE
key_id = 'b3eb442906dc88604fbb37e9454ff72d97eabd6889cc721554b3b5796c6a29fb'
AND (
token = 'q4gS7UZyoc8Ru5uWGFvaDfDRmk30d1PQSqGF640Zvik='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)