UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rjERZIzsw/TlxZ+DcHWzMWEqT6sTyWiRVx05OKVh/Hw='
WHERE
key_id = '196aa97917efcd852a3f4ed2efebe1355a5c0742397b0d38ef84f81a54c69c27'
AND (
token = 'rjERZIzsw/TlxZ+DcHWzMWEqT6sTyWiRVx05OKVh/Hw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)