UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rRwBa9dmZckfjmL5np4M+FaqCVi9EWYE1dM/JnuOCYs='
WHERE
key_id = 'bfcb8e1cb7ab509dc09d645573bfa02be163e141560baa89d8115e2c4771d79e'
AND (
token = 'rRwBa9dmZckfjmL5np4M+FaqCVi9EWYE1dM/JnuOCYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)