UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sTHP4LBP5uHc7TCDJ17SX78mJ1rwAOV/B/pOfd3Qst8='
WHERE
key_id = 'b3e8e087c7f037a7673b6817619b853c98854731f2e88a409dfa53d687599ce4'
AND (
token = 'sTHP4LBP5uHc7TCDJ17SX78mJ1rwAOV/B/pOfd3Qst8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)