UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'X/MXt6WNsBPDXU73zYHmtD5W7Kriygd04ddR6J6facM=' 
WHERE 
  key_id = '867f538de0f63bceb323cf7990a96921356efd5957374a60cb358fefbb25e3fa' 
  AND (
    token = 'X/MXt6WNsBPDXU73zYHmtD5W7Kriygd04ddR6J6facM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030