UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B/s1OChgBorOPZCHkEow1L3QT4mGyeNt8Z2Wgtd8+pA='
WHERE
key_id = 'b0c187b04ca3ade1149dc4043aa35f13f1f913dae3cb995720de65c88e05be4c'
AND (
token = 'B/s1OChgBorOPZCHkEow1L3QT4mGyeNt8Z2Wgtd8+pA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)