UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'bYL4TzPGRjhLa7Xl2VDOZ62g17qdE3CwYUVNMougx/Y=' 
WHERE 
  key_id = '89b9ce8d278edff553ad3041f978f6a2f8c461b0810c82405a7a71bbebf15ce5' 
  AND (
    token = 'bYL4TzPGRjhLa7Xl2VDOZ62g17qdE3CwYUVNMougx/Y=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031